package com.pwt.repository;

import com.pwt.repository.base.BaseRepository;
import com.pwt.entity.AcceptanceLimit;
import org.springframework.data.jpa.repository.Query;

/**
 * AcceptanceLimit Repository层
 *
 * @author auto generated
 * @date 2021-09-29 09:53:59
 */
public interface AcceptanceLimitRepository extends BaseRepository<AcceptanceLimit, String> {

    @Query(nativeQuery = true,value = "select * from acceptance_limit where status = 1")
    public AcceptanceLimit getAcceptanceLimitByStatus();

    @Query(nativeQuery = true,value = "select  * from acceptance_limit where teil=?1 and merkmal=?2")
    public AcceptanceLimit queryByTeilAndMerkmal(Integer k1000,Short k2000);
}
